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

Smashed_Pumpkin
Smashed_Pumpkin Member Posts: 47
edited 2004-03-05 in Navision Attain
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!

Comments

  • Dean_Axon
    Dean_Axon Member Posts: 193
    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
    Remember: Keep it simple
  • Smashed_Pumpkin
    Smashed_Pumpkin Member Posts: 47
    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
    Dean_Axon Member Posts: 193
    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";
    Remember: Keep it simple
  • Smashed_Pumpkin
    Smashed_Pumpkin Member Posts: 47
    Thank you very much Dean, that worked a treat :D

Categories