Import Scenario - Autogenerate Payment Reference based on Existing Sequence.

​@Sydneysturtevant I don't think there is an option rather than giving a ref for import.

Payment method -check has different setting in the Payment method screen,

​@Sydneysturtevant - Might need a clarification here.  For AP bills, that field doesn’t exist (there’s a Vendor Ref. field, though).  Are you trying to import AP Payments with the Payment Ref. field based on the Payment Method AP Last Reference Number?  

Can you share a screenshot of the Allowed Cash Accounts tab of the payment method you are using here?  That may help

How interesting….it’s essentially the check number within our system (Not Reference Nbr.) Column here is the “AP Last Reference Number”

​@Sydneysturtevant - so when it comes to the payment, this is the configuration that does this automatically when you process the check.  If you did want that on the payment, then you may be able to get away with a GI that builds that out for you, but the system does a good job doing it for you.  I may still be a bit unclear on what exactly you’re trying to do, but let me know if the configuration handles it for you.

​@nickcerri32, we current use an import scenario to import checks and their bill application. When I process a check manually through Accumatica, it automatically assigns this number. However, when I import an check batch, I have to manually add the number in.  I’m wondering if there is way to set up the mapping so that it will autogenerate and mirror the manual process we do.