Accounts payable import

Thyda Thach
Thyda Thach
Third Anniversary Kudos 1 Name Dropper Facilitator 1
in Blackbaud Financial Edge NXT® General Discussions

Hi there,

Can anyone help me with importing accounts payable invoices? I was trying to import vendor invoices in FE database view and had a validation error saying that total percent distributed must equal 100%. I understand this error, but in Australia we have GST on good and services which is 10% of gross amount. When we enter invoices we need to account for the 10% GST, therefore the distribution amount should be net of GST. In the import profile, I have also added Tax amount, GST tax ID, Line item description, grant, appeal , payment method and bank account, but non of them came up in the imported invoice.

Regards

Thyda

Comments

  • Kevin Brazell
    Kevin Brazell Blackbaud Employee
    Tenth Anniversary Kudos 5 First Reply Name Dropper

    @Thyda Thach
    Trying to manually do that in import is a much tougher job. Usually when I see that with Canadian clients, as long as their tax settings in configuration are set up, they usually don't have to break that out on the import, so they keep to a more straightforward import without the extra distributions. That being said, what I would likely look for is with that particular error, that no column from the fields tab is missing from the required fields if you're pulling from that area of the fields tab. For example, pulling in distribution for projects, some imports still need percentages as well as amounts, etc. If you left it out, it would toss that same error. So if you can import the invoice without having those extra columns in your file, it's gonna be a simpler import and easier to execute or troubleshoot.

  • Thyda Thach
    Thyda Thach
    Third Anniversary Kudos 1 Name Dropper Facilitator 1

    @Kevin Brazell
    Hi Kevin, thanks for responding, I checked our tax setting in the configuration, they are all set up fine. Our process at the moment is entering invoice manually via accounts payable. We want to eliminate this process hence the import. Usually when we enter the invoices, tax (GST 10% of gross) would come off the invoice automatically and the net amount would appear in the GL distribution tab. The problem I have is when importing an invoice, it does not recognise GST component and the system think that gross amount should be equal to distribution amount, which is incorrect. Have you had any Australian client who faced the same issue? If so how did they managed to get around it?

    Kind regards

    Thyda

  • Kevin Brazell
    Kevin Brazell Blackbaud Employee
    Tenth Anniversary Kudos 5 First Reply Name Dropper

    @Thyda Thach I have not had an Australian client at all, usually due to time difference, I believe they were always assisted by the blackbaud pacific teams, which used to be in Australia, not sure if they are still there. But I would argue if your settings in configuration are correct, then that's a breakdown in the software, as it should work ( I know my Canadian clients that import have not reported a similar issue). Basically, I'd argue you have a potential bug and I'd touch base with FE Support to get the ball rolling.

Categories