chrisbowden
Full Member
 

Doing it all with DBA.
Posts: 106
Gender:
|
We have been having some pricing/billing errors lately that I think I have traced to a data entry error which is being allowed by DBA. When entering an item number in DBA, once the line is complete and the user advances to the next line item, DBA will not allow the user to go back and change the item number of that line. The user must delete the line and re-enter it in order to change the item number. However, DBA will allow the user to change the item number while still editing it during the initial entry. When trying to research the cause of the error, I can reconstruct a scenario as follows: When a user keys an item number and presses Enter, DBA populates the rest of the line with the item description and appropriate pricing. However, occasionally our customer will order something unusual. My data entry clerk has on occasion keyed the usual item number, pressed enter, discovered the mistake, and arrowed back to the item number and changed it. DBA, in this case, will not automatically change/update the item description and the price. The item description can be forced to update by deleting the contents of the cell and entering back through the field which is what I think my clerk has been doing. However, as we have since discovered, DBA will still not update the price. Unfortunately, the unusual item sells at a higher price, but we have been mistakenly billing at a lower price due to this glitch in DBA. If I do not watch the daily order booking report and review the margins, I will not catch it either as my customer's PO does not show the price for my data entry clerk to compare. So, would it be possible to create some logic which will A) get DBA to update the *entire* line if the item number is changed at initial entry time (item description and price), or B) get DBA to not allow the user to change the item number once the item number field has had a valid item number entered into it and then focus has advanced to the next field (sort of like it does now when you try to edit an exisiting SO line)? Thanks! Chris
|