Re: Where is Invoicing freight stored

Lots of programs come with BPCS that often do not do the job we need.
ACR220 Account Statements for example.
When we have access to the source code, we can sometimes clone a version
that does do the job we need.

I have had to do massive new reports in the last year, due to the economy.

We have customers who do not honor our prices and terms when they "pay"
their bills, so we have been generating, by customer, reminder lists of
prices, and dates when those prices were quoted. There's also inconsistency
in tracking RMAs.

We have customers with JIT variants where we order raw materials with 60-90
day lead times to meet customer forecasts where they want their product in
1-2 weeks. They had not been canceling orders, only lowering volume, so we
had to add reports on "slow moving" raw materials on "which customers" it
was originally ordered to satisfy.

-
Al Mac

-----Original Message-----
From: bpcs-l-bounces+macwheel99=wowway.com@xxxxxxxxxxxx
[mailto:bpcs-l-bounces+macwheel99=wowway.com@xxxxxxxxxxxx] On Behalf Of Don
Cavaiani
Sent: Thursday, April 15, 2010 11:58 AM
To: BPCS ERP System
Subject: Re: [BPCS-L] Where is Invoicing freight stored

Thanks Dan! It looks like I should use SIH and SIL in conjunction with
RAR (to check if a balance still due us) to create these customer
statements.

-----Original Message-----
From: bpcs-l-bounces+dcavaiani=amerequip.com@xxxxxxxxxxxx
[mailto:bpcs-l-bounces+dcavaiani=amerequip.com@xxxxxxxxxxxx] On Behalf
Of Dan Sweeney
Sent: Thursday, April 15, 2010 11:50 AM
To: BPCS ERP System
Subject: Re: [BPCS-L] Where is Invoicing freight stored

Don,

The freight charge is not stored as a separate field in the A/R detail
file RAR - it's however stored in the Sales History header file (SIH) in
a field labeled SICHG.


Dan Sweeney - Sr Technical Consultant
PHOENIX Business Consulting, Inc.
Cell: 860.490.6712
www.phoenixbcinc.com



________________________________________
From: bpcs-l-bounces+dsweeney=phoenixbcinc.com@xxxxxxxxxxxx
[bpcs-l-bounces+dsweeney=phoenixbcinc.com@xxxxxxxxxxxx] On Behalf Of Don
Cavaiani [dcavaiani@xxxxxxxxxxxxx]
Sent: Thursday, April 15, 2010 12:25 PM
To: bpcs-l@xxxxxxxxxxxx
Subject: [BPCS-L] Where is Invoicing freight stored

I'm having trouble the file/field where our customer invoice freight
amount is stored? This is our A/R side.

Don F. Cavaiani
IT Manager
Amerequip Corp.
920-894-7063

"It's amazing what you can accomplish if you don't care who gets the
credit." Harry S. Truman