Problem creating new customers (Bill-to / Pay-from codes)

Smashed_Pumpkin

Hi all, wonder if someone could help with this.

When you create a new customer and enter the Bill-to code, the Pay-from code that is assigned to that Bill-to customer does not get entered automatically in the Pay-from field on the new customer card. Is there a way to do this? Many thanks!

Dean_Axon

I'm curious, What is the "Pay From Code" field ??? I had not heard of this field, so I checked in GB 3.60 and GB 3.70 and i cannot find any reference to this field on the standard Customer card ???

What version are you using ??? Is this some kind of custom field on your customer table ??

Dean

Smashed_Pumpkin

I had a feeling we'd added that field ourselves

It's used to deal with 'payment centres', a sort of centralised office where all the cheques for a number of different customers come from. The invoices still go to the Bill-to code address, but the actual payments come from the Pay-from code address (if that makes any sense!).

Dean_Axon

It's used to deal with 'payment centres', a sort of centralised office where all the cheques for a number of different customers come from. The invoices still go to the Bill-to code address, but the actual payments come from the Pay-from code address (if that makes any sense!).

Yes, Perfect sense.

Try something like this:

Create a new variable:
Billto Rec 18

"Bill-to Code" :On Validate Trigger()

Billto.get("Bill-to Customer No.");
"Pay From":=Billto."Pay From";

Smashed_Pumpkin

Thank you very much Dean, that worked a treat