840
Please I need help.
There is anyone who can write a report that will show the following fields:
ItemlookUp Code Opening Quantity Transfer In Transfer Out Closing Stock
I want the report to generate information concerning the above mentioned fields.
Any help, please?
Thank you
*This post is locked for comments
send me an email with your contact information to
ed at bmepos.com
Thank you.
How much will you charge? Can you be able to resolve it?
This is a complex report to create. This is because for each date that is reported on you have to back out sales to the start of that day. Then do you calculations. So this report has the potential problem of taking a long time to generate, especially for days in the distant past.
This would take considerable effort to create, to make sure the calculations are correct and optimize the calculations.
So I would have to charge you something to do this work.
Ok.
The first field, which is ItemLookUp Code show the codes of the item or bar codes.
Opening Quantity shows the first opening stock or quantity of items before actual sales of those items for the day. For example, today's 23/04/2014 and an item's quantity before sales is 10.
Transfer In shows that number of quantity of the item has been brought in respect to the item either through PO or other means of transferring the quantities for the item. For example, if the item is 4 and a Transfer In was made, say 7, then the final quantity is 11.
Transfer Out shows that number of quantity that was out in respect to the item during sales or POs to other stores. If 11 quantities of an item are present, and 10 is transfer out, then the remaining quantity item should be showed.
Closing stock is the quantity left at the end of the day in respect to that item.
Please can you write this report? I need help, please.
Thank you.
@ Ed Boyer
Well, Itemlookup code is the item's code number or barcode
Opening Quantity is the number of quantity as at hand when the store was opened initially
Transfer (in terms of sales between stores) will show number of transfer in done as the same applies to transfer out
Closing stock has to do with the closing of stock in store.
Please help. I need a report on this
Can you explain what each field represents?
I can certainly write the report.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,235
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (