x Want to participate? Join the group to interact
  • State Suggested Answer
  • +1 person also asked this people also asked this
  • Replies 5 replies
  • Answers 1 answer
  • Subscribers 144 subscribers
  • Views 2393 views
  • Users 0 members are here
Browse Forums
Sage 100 Contractor Announcements
119
topics
57
replies
Sage 100 Contractor General Discussion
1k
topics
4k
replies
Sage 300 CRE Announcements
168
topics
526
replies
Sage 300 CRE General Discussion
3k
topics
9k
replies
Sage Construction Management Announcements
4
topics
0
replies
Sage Construction Management General Discussion
16
topics
21
replies
Sage Estimating Announcements
39
topics
3
replies
Sage Estimating General Discussion
189
topics
448
replies
spellj

Inventory Goods Receipt and Payable Invoice Receipt

SUGGESTED
Posted By

New to Sage 100 Contractor with the Inventory Module. I'm having an issue with posting Goods Receipt and the Invoice Receipt.

Goods Receipt was fine. Went to 12-4 and posted 500 units received. Immediately used qty 8 for Inventory Allocation 12-2 to a job.

The next day the Invoice Receipt from the supplier. My AP is entering in 4-2 and the "invoice" is already there transferred from the 12-4 transaction. Then we update with the invoice number and change the record from "Review" to "Open", no issue.  The issue is on attempting to Save.  When we Save the record, Sage has an error saying there is not enough quantity (now 492 since we used 8 of the 500 units)...  I don't know why this is.  We have already received the goods and just want to save the invoice to cut the check to the supplier. Sage will not allow the invoice to be save.

  • 0

    Sorry wrong forum. This is for Sage 100 aka MAS90.  Sage 100 Contractor is an entirely different program.  I think it use to be Timberline.

  • 0 in reply to BigLouie

    Thanks BigLouie.  I'm trying to find the right forum - Timberline, Master Builder... Need some clear direction on where to post this question.

  • 0

    Hello ,

    Moving this post to the Sage 100 Contractor forum in the Sage Construction and Real Estate Support Group.

    Thanks,

    Erzsi

  • 0

    I spoke with Sage support on this. The issue is on my internal process: we were putting freight lines on the invoice and editing the grid. When you edit the grid, it voids the existing transaction and thus there could be an issue with QOH as the invoice is attempting to post the quantity. We are beginning to utilize the Freight cost box on the bottom of the invoice screen, 4-2.

  • 0 in reply to spellj
    SUGGESTED

    Welcome! 

    That is correct.  You can use the freight and variance fields (only once) on the AP record after it was created from the PO receipt.  Please review the 1-8 GL setup window so you are aware of what accounts are affected by entries in those fields, but basically they hit overhead expense accounts because inventory has already changed quantities and you cannot edit the AP record.

    Note:  if however the price is incorrect on the PO by a significant amount, and you need to adjust the value of inventory, then you can enter an AP credit for the totals of each item (which puts in back into inventory) and then enter a brand new invoice for the corrected price (which takes them back out).

*Community Hub is the new name for Sage City