What is the quickest way to get "end of Day" or "end of month" inventory balance.

  • 30 October 2020
  • 5 replies
  • 128 views

Userlevel 4
Badge

Hello,

     I know we are having “Inventory Balance” report (IN615000) and “Historical Inventory Balance” report (IN616000).

     However, Inventory balance report is something like real-time balance, it displays the balance at the time of the report running. History inventory balance can only display the beginning and ending balance of selected periods.

     If my requirement is to record and display the entire warehouse’s inventory balance of each day for the coming week, like from Monday to Sunday. What is the quickest/simplest way to do it.

       All I can think out of is to set a schedule that run “Inventory Balance” on 00:01 every day, and sent this record out as email. And in the final day, I merge them into one excel.

       This is a workable way, but could it be better?


5 replies

Userlevel 4
Badge +4

Hi Ray,

Can you clarify what should be on final day report in above scenario you explained? Generating Inventory balance report using a schedule should work fine as mentioned by you (daily report requirement), but did not quite get the final day part you mentioned. I would like to know that to see if you can have a custom report scheduled to run weekly that gives the number you are looking for. ​​​​​​ 

So, using one case for daily number and one for weekly is what I thought you could use. 

Regards

Vijay

Userlevel 4
Badge

Hi Ray,

Can you clarify what should be on final day report in above scenario you explained? Generating Inventory balance report using a schedule should work fine as mentioned by you (daily report requirement), but did not quite get the final day part you mentioned. I would like to know that to see if you can have a custom report scheduled to run weekly that gives the number you are looking for. ​​​​​​ 

So, using one case for daily number and one for weekly is what I thought you could use. 

Regards

Vijay

@vkumar 
Thank you Vijay,

The perfect picture in my mind is I can get something like
 

Inventory ID Monday Tuesday Wensday Thursday Friday Saturday
Item A 100 110 90 80 60 100
Item B 50 50 70 30 50 50
Item C 30 60 40 70 10 30

 

 

The value displays at end of each day’s qty on hand of that line item.

 

What I can think of is I run data into excel on each day, and merge the data at the weekend, then I could get the merged report as I needed.
But is it the quickest way?

Userlevel 4
Badge +4

Hi @ray20 

What will be the parameter you supply when you run the report ( or intend to supply)? Should the report generate week days based on business date of user session ?

 

Regards,

 

Userlevel 4
Badge

Hi @ray20 

What will be the parameter you supply when you run the report ( or intend to supply)? Should the report generate week days based on business date of user session ?

 

Regards,

 

 

@vkumar Hi, currently, in a single branch and warehouse setting, I can run this “Inventory Balance” report directly on end of each day.
if in a multiple branch and warehouse setting , I shall define the branch and the specific warehouse, that’s all.

The business need behind my question is the business owner would like to know the “end of day” balance. So if “weekdays” can be generated automatically, that would be better, or something like 11/03, 11/04, 11/05, also works fine. no big deal. 
The key of my question is is there a simplest way to log the end of day inventory balance down.

 

 

Userlevel 4
Badge

@vkumar 
 

From this post , it looks like I can get end of day balance  by using “INItemSiteHistD”.

I can use either BegQTy or ENDqty to get the end day inventory balance

Reply


About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2020  Acumatica, Inc. All rights reserved