x Want to participate? Join the group to interact

Sage 100

Welcome to the Sage 100 Support Group on Community Hub! Available 24/7, the Forums are a great place to ask and answer product questions, as well as share tips and tricks with Sage peers, partners, and pros.

Distribution, Manufacturing, and Applications Accounts in product line showing different which implemented in sage100c while fetching the productline list

Accounts in product line showing different which implemented in sage100c while fetching the productline list

Posted By Ambika Rana over 2 years ago

Hi

I wanna know about this thing
i was creating an inventory item and adding product line as well

while creating product line in "Product line code maintenance " i have added the all required accounts like inventory,sales,expense

but when i am fetching the product line list using the table "IM_ProductLine_bus" and these fields for fetching the accounts "

InventoryAcctKey,CostOfGoodsSoldAcctKey,SalesIncomeAcctKey

then why i am getting values like 000000005,00000003,00000002?

If these are accounts key let's say then how can i get the exact accounts which i am applying in product line?

How can i insert these accounts in product line using C# script?

can anyone help me out please

Thank You

Top Replies

Kevin M over 2 years ago +1

You can translate AccountKey into Account by doing a lookup in GL_Account.

For setting based on the Account instead of Key, try this method (example from a SalesOrder line field, so the field name is…

Parents

0 Kevin M over 2 years ago

You can translate AccountKey into Account by doing a lookup in GL_Account.

For setting based on the Account instead of Key, try this method (example from a SalesOrder line field, so the field name is different, but does show the syntax with 3rd argument):

retVal = oBusObj.SetValue("SalesAcctKey$", "425-00-01", "kACCOUNT")
Cancel
Vote Up +1 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 Kevin M over 2 years ago

You can translate AccountKey into Account by doing a lookup in GL_Account.

For setting based on the Account instead of Key, try this method (example from a SalesOrder line field, so the field name is different, but does show the syntax with 3rd argument):

retVal = oBusObj.SetValue("SalesAcctKey$", "425-00-01", "kACCOUNT")
Cancel
Vote Up +1 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

0 Ambika Rana over 2 years ago in reply to Kevin M

I tried the same but i am getting this error "The account number entered has an invalid structure." so could you please look into it?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel