AccountingUS.csv

[adamt...@gmail.com]

Hi All,

Is the import account way changed?

I use steps below,

1. Specify accountingus.csv when setup the client
2. Import accountingus.csv as type accounts
3. Process imported accounts with all tick like update elements, create new combination etc.

I done that for v2 without errors but v4.1 gives errors in console.

Also, sometimes completing material receipt has posting errors. It mainly said product has no cost. I have to click posting error button to complete the posting.

[Carlos Antonio Ruiz Gomez]

> I done that for v2 without errors but v4.1 gives errors in console.

¿?¿?


El 13/11/16 a las 20:45, adamt...@gmail.com escribió:

[adamt...@gmail.com]

Hi Carlos,

Below are my console errors.

Dec 18, 2016 11:12:05 PM org.compiere.model.PO save

WARNING: Set Org to 0

Dec 18, 2016 11:12:05 PM org.compiere.model.PO save

WARNING: Set Org to 0

Dec 18, 2016 11:12:07 PM org.compiere.model.NaturalAccountMap parseLine

SEVERE: Ignored: Require ',' as separator - [Account_Value] [Account_Name] [Account_Description] [Account_Type] [Account_Sign] [Account_Document] [Account_Summary] [Default_Account] [Account_Parent] [Balance Sheet] [Balance Sheet_Name] [US 1120 Balance Sheet] US 1120 Balance Sheet_Name [Profit & Loss] [Profit & Loss_Name] [US 1120 Income Statement] [US 1120 Income Statement_Name] [Cash Flow] [Cash Flow_Name] 

Dec 18, 2016 11:12:07 PM org.compiere.model.NaturalAccountMap parseLine

SEVERE: Ignored: FieldNumber wrong: 8 - 11120,Checking Unidentified Receipts,Receipts from unidentified customer,Asset, ,Yes,No, 11           

Dec 18, 2016 11:12:08 PM org.compiere.model.NaturalAccountMap parseLine

SEVERE: Ignored: FieldNumber wrong: 8 - 12190,Not invoiced receivables,We delivered but have not invoiced yet,Asset, ,Yes,No, 121   2a        

Dec 18, 2016 11:12:08 PM org.compiere.model.NaturalAccountMap parseLine

SEVERE: Ignored: FieldNumber wrong: 8 - 12520,Employee Expense Prepayment,Expense advances,Asset, ,Yes,No, 125   2a        

Dec 18, 2016 11:12:08 PM org.compiere.model.NaturalAccountMap parseLine

SEVERE: Ignored: FieldNumber wrong: 8 - 12620,Tax receivables,Tax to receive based on tax declaration,Asset, ,Yes,No, 126   6        

Dec 18, 2016 11:12:08 PM org.compiere.model.NaturalAccountMap parseLine

SEVERE: Ignored: FieldNumber wrong: 8 - 14100,General Trade Inventory,Inventory Account,Asset, ,Yes,No, 14           

Dec 18, 2016 11:12:08 PM org.compiere.model.NaturalAccountMap parseLine

SEVERE: Ignored: FieldNumber wrong: 8 - 14130,Work In Process,Work In Process Account,Asset, ,Yes,No, 14           

Dec 18, 2016 11:12:08 PM org.compiere.model.NaturalAccountMap parseLine

SEVERE: Ignored: FieldNumber wrong: 8 - 14140,Floor Stock,Floor Stock Account,Asset, ,Yes,No, 14           

Dec 18, 2016 11:12:08 PM org.compiere.model.NaturalAccountMap parseLine

SEVERE: Ignored: FieldNumber wrong: 8 - 21620,Tax liability,Tax to be paid based on tax declaration,Liability, ,Yes,No, 216           

Dec 18, 2016 11:12:08 PM org.compiere.model.NaturalAccountMap parseLine

SEVERE: Ignored: FieldNumber wrong: 8 - 21700,Withholding (Tax),Withholding for 1099 or Quality Guarantee,Liability, ,Yes,No, 21           

Dec 18, 2016 11:12:08 PM org.compiere.model.NaturalAccountMap parseLine

SEVERE: Ignored: FieldNumber wrong: 8 - 32900,Retained Earnings,Year end processing to balance account (Income Summary),Owner's Equity, ,Yes,No, 32           

Dec 18, 2016 11:12:08 PM org.compiere.model.NaturalAccountMap parseLine

SEVERE: Ignored: FieldNumber wrong: 8 - 48000,Not invoiced revenue,We delivered but have not invoiced yet,Revenue, ,Yes,No, 4       1a    

Dec 18, 2016 11:12:08 PM org.compiere.model.NaturalAccountMap parseLine

SEVERE: Ignored: FieldNumber wrong: 8 - 51110,Cost Of Production,Cost Of Production Account,Expense, ,Yes,No, 5           

Dec 18, 2016 11:12:08 PM org.compiere.model.NaturalAccountMap parseLine

SEVERE: Ignored: FieldNumber wrong: 8 - 51120,Scrap,Scrap Account,Expense, ,Yes,No, 5           

Dec 18, 2016 11:12:08 PM org.compiere.model.NaturalAccountMap parseLine

SEVERE: Ignored: FieldNumber wrong: 8 - 51130,Outside Processing (Subcontract),Outside Processing Account,Expense, ,Yes,No, 5           

Dec 18, 2016 11:12:08 PM org.compiere.model.NaturalAccountMap parseLine

SEVERE: Ignored: FieldNumber wrong: 8 - 56300,Inventory Adjustment,Inventory Actual Accounting Value Adjustment,Expense, ,Yes,No, 56           

Dec 18, 2016 11:12:08 PM org.compiere.model.NaturalAccountMap parseLine

SEVERE: Ignored: FieldNumber wrong: 8 - 56400,Inventory Revaluation,Difference to (lower cost) or market,Expense, ,Yes,No, 56           

Dec 18, 2016 11:12:08 PM org.compiere.model.NaturalAccountMap parseLine

SEVERE: Ignored: FieldNumber wrong: 8 - 58400,Using Variance,Account for Using Variance,Expense, ,Yes,No, 58           

Dec 18, 2016 11:12:08 PM org.compiere.model.NaturalAccountMap parseLine

SEVERE: Ignored: FieldNumber wrong: 8 - 58600,Rate Variance,Account for Rate Variance,Expense, ,Yes,No, 58           

Dec 18, 2016 11:12:08 PM org.compiere.model.NaturalAccountMap parseLine

SEVERE: Ignored: FieldNumber wrong: 8 - 58700,Mix Variance,Account for Mix Variance,Expense, ,Yes,No, 58           

Dec 18, 2016 11:12:08 PM org.compiere.model.NaturalAccountMap parseLine

SEVERE: Ignored: FieldNumber wrong: 8 - 68600,Employee expense,Default employee expenses,Expense, ,Yes,No, 68           

Dec 18, 2016 11:12:08 PM org.compiere.model.NaturalAccountMap parseLine

SEVERE: Ignored: FieldNumber wrong: 8 - 70200,Bank Service Charges,Bank expenses,Expense, ,Yes,No, 70           

Dec 18, 2016 11:12:08 PM org.compiere.model.NaturalAccountMap parseLine

SEVERE: Ignored: FieldNumber wrong: 8 - 79300,Suspense error,Import did not find account - needs to be solved,Expense, ,Yes,No, 79           

Dec 18, 2016 11:12:08 PM org.compiere.model.NaturalAccountMap parseLine

SEVERE: Ignored: FieldNumber wrong: 8 - 80510,Bank revaluation gain,Foreign currency bank account gain,Revenue, ,Yes,No, 805           

Dec 18, 2016 11:12:08 PM org.compiere.model.NaturalAccountMap parseLine

SEVERE: Ignored: FieldNumber wrong: 8 - 80520,Bank settlement gain,Difference between payment and bank account currency,Revenue, ,Yes,No, 805           

Dec 18, 2016 11:12:08 PM org.compiere.model.NaturalAccountMap parseLine

SEVERE: Ignored: FieldNumber wrong: 8 - 82510,Bank revaluation loss,Foreign currency bank account loss,Expense, ,Yes,No, 825           

Dec 18, 2016 11:12:08 PM org.compiere.model.NaturalAccountMap parseLine

SEVERE: Ignored: FieldNumber wrong: 8 - 82520,Bank settlement loss,Difference between payment and bank account currency,Expense, ,Yes,No, 825           

Dec 18, 2016 11:12:08 PM org.compiere.model.NaturalAccountMap parseLine

SEVERE: Ignored: FieldNumber wrong: 8 - 83100,Labor (Absorbed),Labor Absorbed account,Expense, ,Yes,No, 83           

Dec 18, 2016 11:12:08 PM org.compiere.model.NaturalAccountMap parseLine

SEVERE: Ignored: FieldNumber wrong: 8 - 83200,Burden (Absorbed),Burden Absorbed account,Expense, ,Yes,No, 83           

Dec 18, 2016 11:12:08 PM org.compiere.model.NaturalAccountMap parseLine

SEVERE: Ignored: FieldNumber wrong: 8 - 83300,Overhead (Applied),Overhead Applied account,Expense, ,Yes,No, 83           

Dec 18, 2016 11:12:08 PM org.compiere.model.NaturalAccountMap parseLine

SEVERE: Ignored: FieldNumber wrong: 8 - 89900,Income Summary,Year end processing to balance account (Retained Earnings),Expense, ,Yes,No, 89     89_ Net Income     

Dec 18, 2016 11:13:19 PM org.compiere.process.SvrProcess unlock

SEVERE: Did not find PInstance 0

Dec 18, 2016 11:13:20 PM org.compiere.model.PO load

SEVERE: NO Data found for AD_Client_ID=1000000

java.lang.Exception

at org.compiere.model.PO.load(PO.java:1347)

at org.compiere.model.PO.load(PO.java:1287)

at org.compiere.model.PO.<init>(PO.java:204)

at org.compiere.model.PO.<init>(PO.java:154)

at org.compiere.model.X_AD_Client.<init>(X_AD_Client.java:38)

at org.compiere.model.MClient.<init>(MClient.java:133)

at org.compiere.model.MClient.<init>(MClient.java:164)

at org.compiere.model.MClient.get(MClient.java:73)

at org.compiere.model.MClient.get(MClient.java:114)

at org.compiere.model.MCountry.loadAllCountries(MCountry.java:118)

at org.compiere.model.MCountry.loadAllCountriesIfNeeded(MCountry.java:107)

at org.compiere.model.MCountry.get(MCountry.java:61)

at org.compiere.model.MLocation.setC_Country_ID(MLocation.java:218)

at org.compiere.model.MLocation.<init>(MLocation.java:178)

at org.compiere.model.MSetup.createEntities(MSetup.java:1121)

at org.adempiere.process.InitialClientSetup.doIt(InitialClientSetup.java:284)

at org.compiere.process.SvrProcess.process(SvrProcess.java:198)

at org.compiere.process.SvrProcess.startProcess(SvrProcess.java:144)

at org.adempiere.util.ProcessUtil.startJavaProcess(ProcessUtil.java:172)

at org.compiere.apps.AbstractProcessCtl.startProcess(AbstractProcessCtl.java:466)

at org.compiere.apps.AbstractProcessCtl.run(AbstractProcessCtl.java:234)

at org.adempiere.webui.apps.WProcessCtl.process(WProcessCtl.java:197)

at org.adempiere.webui.apps.AbstractProcessDialog$ProcessDialogRunnable.doRun(AbstractProcessDialog.java:1061)

at org.adempiere.util.ContextRunnable.run(ContextRunnable.java:38)

at org.adempiere.webui.apps.DesktopRunnable.run(DesktopRunnable.java:40)

at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)

at java.util.concurrent.FutureTask.run(FutureTask.java:266)

at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(ScheduledThreadPoolExecutor.java:180)

at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:293)

at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)

at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)

at java.lang.Thread.run(Thread.java:745)

[Carlos Antonio Ruiz Gomez]

Hi Adam, that looks like wrong file format.

Regards,

Carlos Ruiz


El 18/12/16 a las 16:16, adamt...@gmail.com escribió:

[adamt...@gmail.com]

Hi Carlos Ruiz,

Thanks for answering.

I am using AccountingUS.csv from idempiere server sdk data folder. I did notice there is default accounting csv.

I have found this warning on every new client creation since v4.

Adam.

[Carlos Antonio Ruiz Gómez]

Thanks Adam, must be solved here:

https://bitbucket.org/idempiere/idempiere/commits/781fa76