I am trying to assign a serial number that shows it is on hand, but when I try to assign it to the sales order, it is not available? How do I correct this? Sage 100 v.2017 v 5.40.1.0
Any suggestions on how to correct this would be appreciated.
I am trying to assign a serial number that shows it is on hand, but when I try to assign it to the sales order, it is not available? How do I correct this? Sage 100 v.2017 v 5.40.1.0
Any suggestions on how to correct this would be appreciated.
It gets committed when you select it in Invoice Data Entry or Commit in Sales Order if you have that feature turned on. Your first step is to see if you committed it somewhere else which is why I told…
If the invoice tier data is orphaned (meaning the associated invoice header is not there), you have to clean that up manually.
If you have a repeatable pattern for causing this issue, report to Sage for…
The serial number is probably committed on another sales order or invoice. Go to Item Inquiry, tab 7 Cost Detail and see if it is committed. You can also export the SO_InvoiceTierDistribution and SO_SalesOrderTierDistribution and see if the serial number is listed.
Hi BigLouie,
I see that it is shown in 'other committed' on tab 7. How do I correct this? We are a small company and our IT person is on vacation until June 1?
It gets committed when you select it in Invoice Data Entry or Commit in Sales Order if you have that feature turned on. Your first step is to see if you committed it somewhere else which is why I told you to export those to files and see if the serial number had committed on another order.
It gets committed when you select it in Invoice Data Entry or Commit in Sales Order if you have that feature turned on. Your first step is to see if you committed it somewhere else which is why I told you to export those to files and see if the serial number had committed on another order.
Unfortunately, I don't know how to run those reports and as I stated previously, our IT person is out. I believe what happened was that the order was pending shipment and entered into Invoice Data Entry & got cancelled before shipping but was not deleted properly so the SN is stuck. Will either have to wait for IT to get back or pay Sage Support and have them go in the back door to fix it. Thanks for your help.
Do you know how to use Excel? Then just PULL the files into Excel. Go to Date, Get Data, use ODBC and pull the files. If the serial number is not in there then you will need to use DFDM to go into the costing table and clear the field.
*Community Hub is the new name for Sage City