You’re offline. This is a read only version of the page.
1- Historical IV Trial Balance:
I made receiving transaction entry with one line item qty 300 unit price 114.84
then i tried to check the transaction in the Historical IV Trial Balance but i found the transaction is distributed into two lines
- 299 * 114.84
- 1 * 116.04
Plus that i did sales trx for the same item for all the qty but still showing in the same report qty = 0 ,
and the value = 1.2 (116.04 - 114.84) i have no idea why that happened.
2- AA Budget:
I already created the budget for 2015 in AA Module and i can export to excel the budget layout showing
all the codes ( departments ) with the periods but what about the GL accounts i wanna see the budget for each account for each department ... how can i get this ?
3- Inventory Module:
how to take the inventory status report but date wise for example last month inventory balances
*This post is locked for comments
You are more than welcome,
Dear Mr Mahmoud
thanks a lot for the information your efforts is highly appreciated
Another report that would be of an added value for you, Inventory Item/site Summary – HITB report
Your feedback is highly appreciated,
Hello again,
Those are practically smart and interesting questions, I will try to tackle through them one by one as brief as possible.
Answer for Question (1)
This is the system behavior in order to make sure that the unit cost for the base unit of measurement is recorded precisely without any rounding variances. To explain this, allow me to provide the following example:
Suppose that you are receiving a case of Item A (case includes 6 pieces), which cost is 50, when you enter the receiving you include the cost of the "Case", although, the system will calculate the unit cost of the smallest unit of measurement in order to create a cost layer accordingly.
to calculate the cost of the smallest unit of measurement (piece), you need to divide the unit cost by 6 (since case include 6 pieces), >>> 50/6 = 8.3333333333 , how do you expect the system to handle rounding ?
To handle such situation, the system splits the quantity into two layers (one layer with 1 and the other with 5), and the rounding difference is recorded under the cost layer with the (1) quantity as follows:
- First Layer Cost: Round(8.3333333333,2) = 8.33
- Second Layer Cost: Total Cost (50) - [ Rounded First Layer Cost (8.33) * First Layer Quantity (5)] = 8.35
(5 * 8.33) + (1 * 8.35) = 50
You may check a blog post I have written long time ago on understanding this behavior, Unit Cost and Currency Decimals Setup
I will answer Question (3) since it is inventory related as well;
This cane be retrieved from the historical inventory trial balance report (Reports > Inventory > Activity > Historical Inventory Trial Balance). On this report, there is a parameter for the "date", include the date as of the historical period you want to get.
If you want to create a crystal report or excel-based report, you may check the SQL script posted on my blog under HITB Per Period (Cumulative) – Inventory Balance on a Prior Date
As for Question (2), you need to check the "export account" checkbox when exporting the analytical accounting budget as shown in the screen shot below:
Your feedback is highly appreciated,
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,253
Super User 2024 Season 2
#2
Martin Dráb
230,188
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (