Vendor Creation Error through X++

(0) Share

Report

Posted on by Community Member

When I try to create a new Vendor getting error like

'Cannot create a record in Vendors (VendTable). Vendor account: **** , **** The record already exists.'

There is no such vendor in Vendor Table and I checked NextVal from SystemSequences Table where NextVal is greater than Max(RecId) of VendTable.

Please help me to solve this issue.

Please Find the attachment for reference.

Any suggestion will be greatly appreciated.

Regards,

*This post is locked for comments

I have the same question (0)

All responses (11)

Answers (1)

Suggested answer

axk 925 on at

Like (0)

Report

Hello,

Are you sure that you are inserting vendor with unique AccountNum?

VendTable does not allow duplicates on AccountNum and Party. Maybe you should check which one is causing an error.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi,

yes i am sure that AccountNum is unique and PartyId number sequence is not duplicating.

Was this reply helpful? Yes No
André Arnaud de Cal... 300,924 Super User 2025 Season 2 on at

Like (0)

Report

Hi Chandan,

Can you review all indexes on the VendTable table to see if there is a customization if there are more indexes set to not allow duplicates? Have you actually used the debugger to find out if the AccountNum and Party do get values which are not used before?

If this is not helping, can you share your coding, so we can help you reviewing this?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi,

I have debugged the code and checked whether PartyID is duplicating or not but it is not used before... There is no customization on VendTable indexes.

This is my code:

if(ledgerJournalTransfromSSAS.AccountType == LedgerJournalACType::Vend)

{

checkrecord = vendTable::exist(ledgerJournalTransfromSSAS.AccountNum);

if(checkrecord == false)

{

ttsbegin;

vendTable.clear();

vendTable.AccountNum = ledgerJournalTransfromSSAS.AccountNum;

vendTable.Name = ledgerJournalTransfromSSAS.CustName;

vendTable.VendGroup = ledgerJournalTransfromSSAS.CustGroupId;

vendTable.Currency = ledgerJournalTransfromSSAS.CurrencyCode;

vendTable.LanguageId = 'en-in';

vendTable.PartyType = DirPartyType::Person;

vendTable.insert();

ttscommit;

}

}

Was this reply helpful? Yes No
André Arnaud de Cal... 300,924 Super User 2025 Season 2 on at

Like (0)

Report

Assuming the correct value is passed with the AccountNum field in ledgerJournalTransfromSSAS your code should work.

There is only one thing to know. If you aren't providing a Party reference, the insert logic will overwrite the party type. So it would be better to use the next line in addition (after filling PartyType and before insert:

vendTable.Party = DirPartyTable::createNew(vendTable.partyType, '').RecId;

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi,

I tried the code for Party field still its showing same error...I tried the same logic in test company, Record is inserting in Vendor Table but in Live company its not happening. And also I tried by updating "SystemSequences.NextVal = Max(RecID) from VendTable + 1" and written a test job to insert Test Data but same error.

Was this reply helpful? Yes No
André Arnaud de Cal... 300,924 Super User 2025 Season 2 on at

Like (0)

Report

So the error resides on the production environment only? It would be recommended to create a copy of this instance and start debugging to find out what is really causing the problem. It really should be a duplicate value. Or you didn't provide all information and the code is within a loop where it tries to loop multiple records with the same new vendor.

The code suggestion was not solving the insert error, but is solving the issue on party type if the GAB parameters has Organization as party type for new vendors.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi,

But one change i tried to make is by disabling the PartyID index of VendTable then Insertion is happening but when i debugged the code i.e., DirPartyTable-> GetNewPartyId the PartyID is generating as per Next value of NumberSequence which is not exist in VendTable.

Was this reply helpful? Yes No
Verified answer

André Arnaud de Cal... 300,924 Super User 2025 Season 2 on at

Like (0)

Report

The index should never be disabled. Do you have a certain loop where multiple vendor inserts could be the reason? Can you also check if the party number sequence is set to be NOT continuous? SQL server is not lying. There should be a duplicate.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

No what code i have sent is the only loop where new vendor will be inserted. PartyId number sequence is set to Not Continuous.

Was this reply helpful? Yes No