Pending builds issue

  • 1
  • Question
  • Updated 5 years ago
  • Answered
  • (Edited)
Builds get changed to Marked Pending when Bill is entered.    This would seem like a bug in the software.   Example.  I order items by create a PO.   The items comes in and I receive inventory.   When I do this my inventory goes up by the correct amount.   Then if I do a build of an assembly that uses those items, they get deducted from the total as expected.    All works fine so far.    Then say a month later we get the invoice for the items and the Bill is entered, the program then redates all the items on that Bill from the date they were Received and puts them as on the day the Bill is entered.  So now any builds that had been done prior to the date the Bill is entered get changed to make Pending.  (it acts as though they were never received until the Bill was entered.)  Then I have to run a Marked Pending report and redate all the Builds that had previously been done with the new date of the Bill.  Only then will it let me remove the Pending Builds status and accept the Build.  So I lose all that history of when the builds were actually done and it looks like I had a lot of build down on the day the Bill was entered.
Photo of Ross Headifen

Ross Headifen

  • 300 Points 250 badge 2x thumb

Posted 5 years ago

  • 1
Photo of Ross Headifen

Ross Headifen

  • 300 Points 250 badge 2x thumb
Can any one help with this problem?
Photo of Jason Jiao

Jason Jiao, Alum

  • 1,156 Points 1k badge 2x thumb

Hi Ross,

Welcome to Reckon Community and thank you for you post.

Did you get the following warning message when you try to Enter Bills for Received Items? 

This is by Product Design. These are a few scenarios that the Build status can be affected.

1. (Your Case) If you receive component inventory parts separate from a bill, enter the Receive Items into Reckon Accounts, and build assemblies using those component parts. If you receive the bill for component inventory parts after you build the assembly, you could accidentally cause your build to change to pending when you pay the bill. This happens because a bill payment transaction changes the item receipt date for the component inventory items received. If the bill date is later than the build date, Reckon Accounts assumes there were not enough component parts available in inventory to build the assemblies you requested on the build date (even if the build has already occurred), and marks the build as pending.

2. If you create a sales transaction, such as an invoice, sales receipt containing assembled inventory, and then manually change the date of the transaction to a date prior to the assembly build date. While the assembly items appear to be available in inventory as you create the invoice, when you save the invoice and the invoice transaction is posted in Reckon Accounts, it assumes the assembled units were not available on the day the build was generated and the status of the build is changed to pending. This situation can be compounded when the assembly affected is a component of another assembly item and was used in other build transactions. In this case, many assemblies in the nested hierarchy could change to pending when only one transaction is modified.

3. If you purchase additional component items and increase the quantity of one or more component items in an assembly. If the build transaction for this assembly occurs after the date of the purchase transaction, the build transaction is dependent on the component quantity specified in the purchase transaction. If the purchase transaction is then moved (postdated) after the build transaction date or is deleted, the build transaction is changed to pending.

Regards

Jason



(Edited)
Photo of Ross Headifen

Ross Headifen

  • 300 Points 250 badge 2x thumb

Thanks for the reply.  Yes what you describe is correct and that is the bug the program has.   We receive the items before the bill.  Then we do builds to incorporate these items into the final built product which we can then sell.   Then a few weeks or so later we get the bill.  When it is entered it changes the receipt to a bill and redates the receipt of those items associated with the bill to the bill date.  Therefore all the previously built items now go pending as they were built before the date of the bill.   This is a problem, in that 1) It means we have to go back to find those pending builds and redate them to todays date to remove the pending status and 2) we lose the actual date history of when the builds were done as now they all have todays date. 

The receipt date of the items should not be changed when the bill is entered.


Ross

Photo of Jason Jiao

Jason Jiao, Alum

  • 1,156 Points 1k badge 2x thumb

Hi Ross,

Due to the Item Receipt and Bill being one and the same transaction, it can only store one date. However I will pass your feedback to our development team.

Thanks

Jason

Photo of Ross Headifen

Ross Headifen

  • 300 Points 250 badge 2x thumb

Yes it is a shame it is like that.  Some one needs to think this through properly.   yesterday we had to back and rebuild a dozen assemblies as the bill came in late and we had done all these build after the receipt of the good came in.


Also have you seen my post about the incorrect build costs being used?

Ross