ISTech Support Forum

ISTech Support Forum
http://www.istechforum.com/YaBB.pl
Evo-ERP and DBA Classic >> Sales >> To space or Not to Space
http://www.istechforum.com/YaBB.pl?num=1141843396

Message started by rmh148 on 03/08/06 at 10:43:16

Title: To space or Not to Space
Post by rmh148 on 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.

Title: Re: To space or Not to Space
Post by Lynn Pantic on 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.