| |

VerySource

 Forgot password?
 Register
Search
View: 24|Reply: 6

Count the daily storage of various products, send out, and inventory on the day

[Copy link]

1

Threads

3

Posts

2

Credits

Newbie

Rank: 1

Credits
2

 China

Post time: 2020-1-5 12:40:01
| Show all posts |Read mode
How to calculate three fields: storage-issue + previous day inventory = same day inventory
Reply

Use magic Report

1

Threads

3

Posts

2

Credits

Newbie

Rank: 1

Credits
2

 China

 Author| Post time: 2020-1-5 18:15:01
| Show all posts
Will everyone? I give more
Reply

Use magic Report

1

Threads

3

Posts

2

Credits

Newbie

Rank: 1

Credits
2

 China

 Author| Post time: 2020-1-5 18:18:01
| Show all posts
Storage, dispatch, same-day stock
Reply

Use magic Report

0

Threads

3

Posts

3

Credits

Newbie

Rank: 1

Credits
3

 China

Post time: 2020-1-6 19:24:01
| Show all posts
It is recommended to use SCAN ..... ENDSCAN, this will be much faster than using SQL statements, and the general posting is only within 1S.
Reply

Use magic Report

0

Threads

12

Posts

9

Credits

Newbie

Rank: 1

Credits
9

 China

Post time: 2020-1-20 14:27:01
| Show all posts
update table name set inventory of the day = storage-issue + previous inventory
Reply

Use magic Report

0

Threads

3

Posts

2

Credits

Newbie

Rank: 1

Credits
2

 China

Post time: 2020-1-21 21:09:01
| Show all posts
For the general approach, the corresponding inventory must be directly modified every time it goes out of the warehouse and into the warehouse, that is, the inventory is dynamic.
Reply

Use magic Report

0

Threads

2

Posts

3

Credits

Newbie

Rank: 1

Credits
3

 China

Post time: 2020-4-24 17:00:01
| Show all posts
Jack up for.
Reply

Use magic Report

You have to log in before you can reply Login | Register

Points Rules

Contact us|Archive|Mobile|CopyRight © 2008-2020|verysource.com ( 京ICP备17048824号-1 )

Quick Reply To Top Return to the list