x Want to participate? Join the group to interact
  • Replies 22 replies
  • Subscribers 75 subscribers
  • Views 3269 views
  • Users 0 members are here
Browse Forums
Announcements
78
topics
166
replies
General Discussion
5k
topics
16k
replies
Installation and Upgrades
978
topics
2k
replies
Inventory, Projects, and Departments
339
topics
1k
replies
Payables and Receivables
1k
topics
4k
replies
Payroll
1k
topics
3k
replies
Reconciliation and Banking
318
topics
995
replies
Reporting and Analytics
207
topics
400
replies
Soutien Technique - Français
628
topics
1k
replies
Year End Activities
224
topics
595
replies
Denver Flynn

Sage 50c rounding off the Unit Cost/Amount inconsistently between different Journals?

Posted By

Hello,

We're using Sage 50c Premium ver. 2021 and have set up our inventory ledger based on FIFO and not allowing negative inventory. 

For one particular "Item ABC", we purchased 200 units at USD 1.1 each, and at the exchange rate of 1.2607. The Inventory list shows the Total Value of CAD 277.35. 

When this item is called up in the Assembly Journal, Sage displays the Total Amount as CAD 277.36 for 200 units.

Because of this $0.01 difference, Sage wouldn't let us post the Assembly or Sales transaction using all 200 units as it expects to find CAD 277.36 Total Value and there's only 277.35 in the Inventory record. 

Are Sage users expected to manually revalue some individual inventory items via Adjust Inventory if using FIFO costing? That is, for the problem items take all units out, and then put them back with the Total Value expected in the item record, by, in this case, Item Assembly Journal? Wouldn't doing this all the time create other issues to affect costing long term?

Parents

  • What more, different quantities of the item entered in the Item Asssembly or Sales Invoice journals result in different unit cost displayed/posted:

    Q'ty 1 entered -- Unit Cost shown as 1.39 -- Total Amount is CAD 139.00

    Q'ty 10 -- Unit Cost 1.387 -- Total Amount is CAD 138.70

    Q'ty 100 -- Unit Cost 1.3868 -- Total Amount is CAD 138.68

    Eventually, after posting a few sales transactions at diferent unit quantity one finds that the Quantity on Hand for the item and the Total Value are out of sync because of these rounding differences that compound in the item inventory record throwing off the Total Value by a few cents. As you remember, we're using FIFO costing and there are rigid unit cost layers in place.

    So am I missing something here, is this the "normal" behavior of Sage 50c? 

Reply

  • What more, different quantities of the item entered in the Item Asssembly or Sales Invoice journals result in different unit cost displayed/posted:

    Q'ty 1 entered -- Unit Cost shown as 1.39 -- Total Amount is CAD 139.00

    Q'ty 10 -- Unit Cost 1.387 -- Total Amount is CAD 138.70

    Q'ty 100 -- Unit Cost 1.3868 -- Total Amount is CAD 138.68

    Eventually, after posting a few sales transactions at diferent unit quantity one finds that the Quantity on Hand for the item and the Total Value are out of sync because of these rounding differences that compound in the item inventory record throwing off the Total Value by a few cents. As you remember, we're using FIFO costing and there are rigid unit cost layers in place.

    So am I missing something here, is this the "normal" behavior of Sage 50c? 

Children
No Data

*Community Hub is the new name for Sage City