Welcome, Guest. Please Login.
05/18/25 at 21:18:13
News:
Home Help Search Login


Pages: 1
Send Topic Print
To space or Not to Space (Read 259 times)
rmh148
Member
**




Posts: 84
To space or Not to Space
03/08/06 at 10:43:16
 
Looking for consistency.  I have a few questions and concerns about Invoicing.  My observations indicate that when you invoice out of sales order screen the transaction is recorded in BKARINV_B, but when you do a voucher/voucher via AR-B screen it writes directly to BKAPHINV.  Straight to HISTORY.  This has created a reconcilitation problem in that most sales reports are looking for current months detail in BKARINV and therefore do not balance to the GL transactions posted during the month.  Both post to BKGLTRAN .  However, when these transactions post to BKGLTRAN they are suppose to store the invoice number in the BKGL_TRN_INVC field.  Problem is that transactions from AR-B writes to it as left justified (no leading space) while Sales order screen write to it with a space then the invoice number.  Should be consistant leading space or no leading space.  Added note:  when records are written to BKARINV_B.BKAR_INV_TERMD via sales order screen a leading space is place on NET 30 and two spaces on COD.  But when records are written to BKARHINV_B.BKAR_INV_TERMD via AR-B no leading spaces NET 30.
Back to top
 
 
  IP Logged
Lynn_Pantic
Administrator
*****


evolution (n) -
gradual change to a
different form

Posts: 5663
Re: To space or Not to Space
Reply #1 - 03/13/06 at 07:33:54
 
Sales reports (as opposed to Bookings Reports) are always looking at posted invoices rather than Sales Orders so they would all be looking at the BKARHINV/BKARHIVL files.  However, any reports looking at Line Item Detail would ignore anything entered as a Voucher because by definition there are no line items.  
 
Reconciling GL Totals with Invoice Totals (SA-B or SA-N or SO-O-H) should always match.
Back to top
 
 

Lynn Pantic
IS Tech Support
lynn@istechsupport.com
Email   IP Logged
Pages: 1
Send Topic Print