Invoice Addresses

[jonbarr]

Using GP v 8.00
We have some National customers who require invoices to be sent to the branch which ordered and received goods from us, rather than to Head Office. This is not provided for at present, as each customer can have only one "Bill To" address.

In the past, we have dealt with this problem by setting up each branch as a separate account Child of a Head Office Parent account.
This method involves us in considerably more work whenever a price change needs to be implemented, as each child has to be updated separately in our Advanced Pricing system.

We would like to know if the following idea is feasible.
Say the customer has 3 branches, Auckland, Hamilton and Taupo.
We set up three delivery addresses called Auckland, Hamilton and Taupo.
We set up three further POSTAL addresses called ZAuckland, ZHamilton and ZTaupo.
(this means they will be separated from the Delivery addresses and grouped at the bottom of the address list)

Now, can our Invoice form be modified in Report Writer so that the Delivery address appears as at present in the right hand Shipped To box,
BUT the Left hand Bill To box is populated with an appropriate Postal address based on the delivery address.
I imagine this would be a calculated field along the lines of " If the Ship To address is Taupo then print ZTaupo".

Any comments, ideas or suggestions would be welcome.

 

[jazgeek]

what version of GP are you using?

National accoutns takes care of this.



-----------
and they wonder why they call it Great Pains!

jaz

 

[jonbarr]

Hi jaz
Nice to hear from you again.
We're using version 8, and as I tried to explain, the National account scheme is what we have used in the past, but for a number of reasons it is not ideal for us. We are using a third party product "Advanced Pricing" (in order to be able to have different prices for each item to each 'Ship To' address), and this means that if we have a global price change for the Parent and all of the children, each has to be entered individually - a considerable task.
We would much prefer to have a single account, with a 'Ship To' address for each branch.
We use a modified report for our invoice form, but I have not had much experience with Report Writer (as I prefer to use Crystal) and I was hoping someone with a good knowledge of Report Writer could advise me if a calculated field could be written along the lines of my suggestion.

 

[jazgeek]

there's a product from Horizons called item pricing matrix... it does by customer/item/qty... pretty nifty

might want to give that a looksee

-----------
and they wonder why they call it Great Pains!

jaz

 

[winthropdc]

You could also check out Omni Price from

http://www.winthropdc.com.

It can have different contracts assigned to different Ship To addresses using a separate customer filter for each Ship To address ID.

This is a customer pricing addon that David wrote before becoming a Microsoft employee. You can download it and trial it yourself without reg keys.

Jennifer Musgrave
Winthrop Dexterity Consultants
The Home of Omni Tools and Omni Price

http://www.winthropdc.com