Welcome, Guest. Please Login.
05/09/25 at 20:08:47
News:
Home Help Search Login


Pages: 1
Send Topic Print
Sales order line item data entry errors (Read 1081 times)
chrisbowden
Full Member
***


Doing it all with
DBA.

Posts: 106
Gender: male
Sales order line item data entry errors
09/26/05 at 02:37:36
 
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
Back to top
 
 

Chris Bowden
Amstar Foods LLC
ISTech 2004.1 12/21/08 - 5 user - Classic & Evo - patch as of 01/07/09
Pervasive 2000i SP3 / XP Pro
  IP Logged
David Waldmann
Active Member
*****


Live to work, or
work to live?

Posts: 1919
Gender: male
Re: Sales order line item data entry errors
Reply #1 - 09/26/05 at 04:09:50
 
You must not have the latest version of SO-A.
 
With the current version, when entering the line the first time once you <Enter> past the Item number, if you attempt to go back it takes you all the way back to the Line Number field and erases everything. If you get as far as the UM field it won't let you go back at all.
Back to top
 
 

David N Waldmann
President
Vermont Hardwoods
Chester, VT

Evo-ERP, 5 user
IST Build: 3/4/19, patched 04/30/19
Pervasive v11.31
Server 2012 / Win10 x64
Crystal Reports v11
Email WWW   IP Logged
Cyndee Pappas
Senior Member
****


EVO~ERP 2006.1
02/28/06 update

Posts: 258
Gender: female
Re: Sales order line item data entry errors
Reply #2 - 09/26/05 at 07:59:19
 
David, what dates are your files? I'm running the 6/20 update and mine behaves as Chris describes.
 
I've got a BKSOA.RUN and BKSOA2.RUN both dated 7/1/05.
 
Banner dates are 6/10/0 (not a typo, it says 6/10/0) on the header screen and 5/9/05 on the line item screen.
Back to top
 
 

Cyndee Pappas
Industrial Data Systems
EVO~ERP 2006.1 with 02/28/06 update
Client/Server Win2000 Server
Pervasive SQL 2000i

WWW   IP Logged
Lynn_Pantic
Administrator
*****


evolution (n) -
gradual change to a
different form

Posts: 5663
Re: Sales order line item data entry errors
Reply #3 - 09/26/05 at 09:55:13
 
Cyndee is right - once you get to the Qty and up arrow, it takes you back to the Line Number but doesn't clear the information so you can end up with the problem Chris originally described.  Will take a look, I agree, when changing a part number before the line is saved, all the other information should clear and change as well.
Back to top
 
 

Lynn Pantic
IS Tech Support
lynn@istechsupport.com
Email   IP Logged
Lynn_Pantic
Administrator
*****


evolution (n) -
gradual change to a
different form

Posts: 5663
Re: Sales order line item data entry errors
Reply #4 - 09/26/05 at 14:28:30
 
OK, we got part of it fixed for this update and will take care of the other part for the next one.  If you up arrow and change the part number, the price now pulls in for the new part number.  Description, unfortunately, does not; that will be fixed for the next update.
Back to top
 
 

Lynn Pantic
IS Tech Support
lynn@istechsupport.com
Email   IP Logged
David Waldmann
Active Member
*****


Live to work, or
work to live?

Posts: 1919
Gender: male
Re: Sales order line item data entry errors
Reply #5 - 09/27/05 at 06:01:02
 
Quote from Cyndee Pappas   on 09/26/05 at 07:59:19:
David, what dates are your files? I'm running the 6/20 update and mine behaves as Chris describes.

I've got a BKSOA.RUN and BKSOA2.RUN both dated 7/1/05.

Banner dates are 6/10/0 (not a typo, it says 6/10/0) on the header screen and 5/9/05 on the line item screen.

I figured it out. I'm using an older version, because I don't like that the latest version CONVERTS EVERYTHING TO ALL CAPS, so I reverted to the earlier one. Hopefully the newest one will not only solve the ALL CAPS problem, but also that it sets Original Qty to Zero on Kit type items.
Back to top
 
 

David N Waldmann
President
Vermont Hardwoods
Chester, VT

Evo-ERP, 5 user
IST Build: 3/4/19, patched 04/30/19
Pervasive v11.31
Server 2012 / Win10 x64
Crystal Reports v11
Email WWW   IP Logged
Lynn_Pantic
Administrator
*****


evolution (n) -
gradual change to a
different form

Posts: 5663
Re: Sales order line item data entry errors
Reply #6 - 09/27/05 at 07:02:22
 
9/25 update now available does fix the Convert to CAPS problem.  
 
David - please refresh my memory on the Kit Quantity issue.
Back to top
 
 

Lynn Pantic
IS Tech Support
lynn@istechsupport.com
Email   IP Logged
Vman
Senior Member
****


If it ain't broke,
don't fix it

Posts: 460
Gender: male
Re: Sales order line item data entry errors
Reply #7 - 09/27/05 at 07:05:44
 
Quote from Lynn Pantic   on 09/27/05 at 07:02:22:
9/25 update now available does fix the Convert to CAPS problem. 

 
YEAH!--- Oops, I mean Yeah!
 
Back to top
 
 

EVO-ERP 2022.2
Build 4/22/22
Actican Zen V14 SP2 Workgroup
Win7 64-bit and Win10 Pro
WWW   IP Logged
David Waldmann
Active Member
*****


Live to work, or
work to live?

Posts: 1919
Gender: male
Re: Sales order line item data entry errors
Reply #8 - 09/28/05 at 03:41:46
 
Quote from Lynn Pantic   on 09/27/05 at 07:02:22:
David - please refresh my memory on the Kit Quantity issue.

Type K Items do not get an Original Quantity amount put in.
 
Interestingly enough, the new SO-A no longer displays the Original Qty in the box for it above the line item detail even on non-Kit items, but apparently it does track it, as on non-Kit items it does ask you if you want to change the Original Quantity when changing.
Back to top
 
 

David N Waldmann
President
Vermont Hardwoods
Chester, VT

Evo-ERP, 5 user
IST Build: 3/4/19, patched 04/30/19
Pervasive v11.31
Server 2012 / Win10 x64
Crystal Reports v11
Email WWW   IP Logged
Pages: 1
Send Topic Print