You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@ofbiz.apache.org by Mike <mz...@gmail.com> on 2011/12/31 08:34:46 UTC
Accounting preferences and blank SeqCustMethod's
After setting up my test company (US_IRS_1040), the following
interesting fields (****) were blank in PartyAcctgPreference.
partyId Company
invoiceSeqCustMethId INV_HOOK_ENF_SEQ
quoteSeqCustMethId ****
orderSeqCustMethId ****
refundPaymentMethodId ****
errorGlJournalId ERROR_JOURNAL
oldInvoiceSequenceEnumId INVSQ_ENF_SEQ
oldOrderSequenceEnumId ODRSQ_ENF_SEQ
oldQuoteSequenceEnumId QTESQ_ENF_SEQ
Is it OK that they are blank, or is there a recommended value to set these to?
Thanks
Re: Accounting preferences and blank SeqCustMethod's
Posted by Jacques Le Roux <ja...@les7arts.com>.
Mike,
You only need them if you want to enforce sequences (ie have no holes in Ids sequences). Short and rough explanation: OFBiz uses an
Id Seq. optimisation mechanism which allocates blocks of Ids (see SequenceBank.fillBank() method in SequenceUtil.java) . If, for
instance, you restart your machine then you will get a hole because a new block will be allocated and some Ids lost. This is really
annoying for invoices, that's why you have by default
> invoiceSeqCustMethId="INV_HOOK_ENF_SEQ"
But it's less annoying for quotes an orders. So if you don't need enforsed seq. ids for your quotes an orders, then you can forget
them
> oldInvoiceSequenceEnumId="INVSQ_ENF_SEQ"
> oldOrderSequenceEnumId="ODRSQ_ENF_SEQ"
> oldQuoteSequenceEnumId="QTESQ_ENF_SEQ"
Are not methods but the fields references in CustomMethod Entity.
Jacques
From: "Mike" <mz...@gmail.com>
> Thanks Jacques:
>
> I was wondering about these "old" methods:
>
> invoiceSeqCustMethId="INV_HOOK_ENF_SEQ"
> quoteSeqCustMethId="INV_HOOK_ENF_SEQ"
> orderSeqCustMethId="INV_HOOK_ENF_SEQ"
>
> oldInvoiceSequenceEnumId="INVSQ_ENF_SEQ"
> oldOrderSequenceEnumId="ODRSQ_ENF_SEQ"
> oldQuoteSequenceEnumId="QTESQ_ENF_SEQ"
>
> Do I need to these old* methods if I set the above three? Are they
> deprecated?
>
> I'm trying to pre-populate PartyAcctgPreference from seed data (if that is
> possible). There are no existing transactions yet.
>
> Thanks
>
> On Sat, Dec 31, 2011 at 2:55 AM, Jacques Le Roux <
> jacques.le.roux@les7arts.com> wrote:
>
>> Hi Mike,
>>
>> Ho yes, I forgot to say that the 2 others CustMethId fields are not in
>> DemoGlSetupData.xml /PartyAcctgPreference entity. I think because we don't
>> want to have them OOTB in demo data. But of course you can use them if it
>> makes sense to you (check their implementations). So it seems you are using
>> demo data...
>>
>> Jacques
>>
>> From: "Mike" <mz...@gmail.com>
>>
>> Thanks Jacques. I'm using 11.04 seeded data. Also, trunk is similar
>>> when viewed through WebTools:
>>>
>>> https://demo-trunk.ofbiz.**apache.org/webtools/control/**
>>> ViewGeneric?entityName=**PartyAcctgPreference&partyId=**Company<https://demo-trunk.ofbiz.apache.org/webtools/control/ViewGeneric?entityName=PartyAcctgPreference&partyId=Company>
>>>
>>> These fields are also blank in trunk, so I'm just wondering what to do.
>>>
>>> Mike
>>>
>>> On Sat, Dec 31, 2011 at 1:57 AM, Jacques Le Roux
>>> <ja...@les7arts.com> wrote:
>>>
>>>> The CustMethId fields are related to the CustomMethod Entity.
>>>> INV_HOOK_ENF_SEQ use invoiceSequence-enforced. The others are in
>>>> AccountingTypeData.xml which is seed data in trunk. So I guess either you
>>>> are using a release where they were not already set or you had an issue
>>>> while seeding your DB...
>>>>
>>>> For refundPaymentMethodId you have to pick one into the refund methods in
>>>> CustomMethod Entity or to create your own...
>>>>
>>>> Jacques
>>>>
>>>> From: "Mike" <mz...@gmail.com>
>>>>
>>>> After setting up my test company (US_IRS_1040), the following
>>>>> interesting fields (****) were blank in PartyAcctgPreference.
>>>>>
>>>>> partyId Company
>>>>> invoiceSeqCustMethId INV_HOOK_ENF_SEQ
>>>>> quoteSeqCustMethId ****
>>>>> orderSeqCustMethId ****
>>>>> refundPaymentMethodId ****
>>>>> errorGlJournalId ERROR_JOURNAL
>>>>> oldInvoiceSequenceEnumId INVSQ_ENF_SEQ
>>>>> oldOrderSequenceEnumId ODRSQ_ENF_SEQ
>>>>> oldQuoteSequenceEnumId QTESQ_ENF_SEQ
>>>>>
>>>>> Is it OK that they are blank, or is there a recommended value to set
>>>>> these
>>>>> to?
>>>>>
>>>>> Thanks
>>>>>
>>>>
>>>
>
Re: Accounting preferences and blank SeqCustMethod's
Posted by Mike <mz...@gmail.com>.
Thanks Jacques:
I was wondering about these "old" methods:
invoiceSeqCustMethId="INV_HOOK_ENF_SEQ"
quoteSeqCustMethId="INV_HOOK_ENF_SEQ"
orderSeqCustMethId="INV_HOOK_ENF_SEQ"
oldInvoiceSequenceEnumId="INVSQ_ENF_SEQ"
oldOrderSequenceEnumId="ODRSQ_ENF_SEQ"
oldQuoteSequenceEnumId="QTESQ_ENF_SEQ"
Do I need to these old* methods if I set the above three? Are they
deprecated?
I'm trying to pre-populate PartyAcctgPreference from seed data (if that is
possible). There are no existing transactions yet.
Thanks
On Sat, Dec 31, 2011 at 2:55 AM, Jacques Le Roux <
jacques.le.roux@les7arts.com> wrote:
> Hi Mike,
>
> Ho yes, I forgot to say that the 2 others CustMethId fields are not in
> DemoGlSetupData.xml /PartyAcctgPreference entity. I think because we don't
> want to have them OOTB in demo data. But of course you can use them if it
> makes sense to you (check their implementations). So it seems you are using
> demo data...
>
> Jacques
>
> From: "Mike" <mz...@gmail.com>
>
> Thanks Jacques. I'm using 11.04 seeded data. Also, trunk is similar
>> when viewed through WebTools:
>>
>> https://demo-trunk.ofbiz.**apache.org/webtools/control/**
>> ViewGeneric?entityName=**PartyAcctgPreference&partyId=**Company<https://demo-trunk.ofbiz.apache.org/webtools/control/ViewGeneric?entityName=PartyAcctgPreference&partyId=Company>
>>
>> These fields are also blank in trunk, so I'm just wondering what to do.
>>
>> Mike
>>
>> On Sat, Dec 31, 2011 at 1:57 AM, Jacques Le Roux
>> <ja...@les7arts.com> wrote:
>>
>>> The CustMethId fields are related to the CustomMethod Entity.
>>> INV_HOOK_ENF_SEQ use invoiceSequence-enforced. The others are in
>>> AccountingTypeData.xml which is seed data in trunk. So I guess either you
>>> are using a release where they were not already set or you had an issue
>>> while seeding your DB...
>>>
>>> For refundPaymentMethodId you have to pick one into the refund methods in
>>> CustomMethod Entity or to create your own...
>>>
>>> Jacques
>>>
>>> From: "Mike" <mz...@gmail.com>
>>>
>>> After setting up my test company (US_IRS_1040), the following
>>>> interesting fields (****) were blank in PartyAcctgPreference.
>>>>
>>>> partyId Company
>>>> invoiceSeqCustMethId INV_HOOK_ENF_SEQ
>>>> quoteSeqCustMethId ****
>>>> orderSeqCustMethId ****
>>>> refundPaymentMethodId ****
>>>> errorGlJournalId ERROR_JOURNAL
>>>> oldInvoiceSequenceEnumId INVSQ_ENF_SEQ
>>>> oldOrderSequenceEnumId ODRSQ_ENF_SEQ
>>>> oldQuoteSequenceEnumId QTESQ_ENF_SEQ
>>>>
>>>> Is it OK that they are blank, or is there a recommended value to set
>>>> these
>>>> to?
>>>>
>>>> Thanks
>>>>
>>>
>>
Re: Accounting preferences and blank SeqCustMethod's
Posted by Jacques Le Roux <ja...@les7arts.com>.
Hi Mike,
Ho yes, I forgot to say that the 2 others CustMethId fields are not in DemoGlSetupData.xml /PartyAcctgPreference entity. I think
because we don't want to have them OOTB in demo data. But of course you can use them if it makes sense to you (check their
implementations). So it seems you are using demo data...
Jacques
From: "Mike" <mz...@gmail.com>
> Thanks Jacques. I'm using 11.04 seeded data. Also, trunk is similar
> when viewed through WebTools:
>
> https://demo-trunk.ofbiz.apache.org/webtools/control/ViewGeneric?entityName=PartyAcctgPreference&partyId=Company
>
> These fields are also blank in trunk, so I'm just wondering what to do.
>
> Mike
>
> On Sat, Dec 31, 2011 at 1:57 AM, Jacques Le Roux
> <ja...@les7arts.com> wrote:
>> The CustMethId fields are related to the CustomMethod Entity.
>> INV_HOOK_ENF_SEQ use invoiceSequence-enforced. The others are in
>> AccountingTypeData.xml which is seed data in trunk. So I guess either you
>> are using a release where they were not already set or you had an issue
>> while seeding your DB...
>>
>> For refundPaymentMethodId you have to pick one into the refund methods in
>> CustomMethod Entity or to create your own...
>>
>> Jacques
>>
>> From: "Mike" <mz...@gmail.com>
>>
>>> After setting up my test company (US_IRS_1040), the following
>>> interesting fields (****) were blank in PartyAcctgPreference.
>>>
>>> partyId Company
>>> invoiceSeqCustMethId INV_HOOK_ENF_SEQ
>>> quoteSeqCustMethId ****
>>> orderSeqCustMethId ****
>>> refundPaymentMethodId ****
>>> errorGlJournalId ERROR_JOURNAL
>>> oldInvoiceSequenceEnumId INVSQ_ENF_SEQ
>>> oldOrderSequenceEnumId ODRSQ_ENF_SEQ
>>> oldQuoteSequenceEnumId QTESQ_ENF_SEQ
>>>
>>> Is it OK that they are blank, or is there a recommended value to set these
>>> to?
>>>
>>> Thanks
>
Re: Accounting preferences and blank SeqCustMethod's
Posted by Mike <mz...@gmail.com>.
Thanks Jacques. I'm using 11.04 seeded data. Also, trunk is similar
when viewed through WebTools:
https://demo-trunk.ofbiz.apache.org/webtools/control/ViewGeneric?entityName=PartyAcctgPreference&partyId=Company
These fields are also blank in trunk, so I'm just wondering what to do.
Mike
On Sat, Dec 31, 2011 at 1:57 AM, Jacques Le Roux
<ja...@les7arts.com> wrote:
> The CustMethId fields are related to the CustomMethod Entity.
> INV_HOOK_ENF_SEQ use invoiceSequence-enforced. The others are in
> AccountingTypeData.xml which is seed data in trunk. So I guess either you
> are using a release where they were not already set or you had an issue
> while seeding your DB...
>
> For refundPaymentMethodId you have to pick one into the refund methods in
> CustomMethod Entity or to create your own...
>
> Jacques
>
> From: "Mike" <mz...@gmail.com>
>
>> After setting up my test company (US_IRS_1040), the following
>> interesting fields (****) were blank in PartyAcctgPreference.
>>
>> partyId Company
>> invoiceSeqCustMethId INV_HOOK_ENF_SEQ
>> quoteSeqCustMethId ****
>> orderSeqCustMethId ****
>> refundPaymentMethodId ****
>> errorGlJournalId ERROR_JOURNAL
>> oldInvoiceSequenceEnumId INVSQ_ENF_SEQ
>> oldOrderSequenceEnumId ODRSQ_ENF_SEQ
>> oldQuoteSequenceEnumId QTESQ_ENF_SEQ
>>
>> Is it OK that they are blank, or is there a recommended value to set these
>> to?
>>
>> Thanks
Re: Accounting preferences and blank SeqCustMethod's
Posted by Jacques Le Roux <ja...@les7arts.com>.
The CustMethId fields are related to the CustomMethod Entity. INV_HOOK_ENF_SEQ use invoiceSequence-enforced. The others are in
AccountingTypeData.xml which is seed data in trunk. So I guess either you are using a release where they were not already set or you
had an issue while seeding your DB...
For refundPaymentMethodId you have to pick one into the refund methods in CustomMethod Entity or to create your own...
Jacques
From: "Mike" <mz...@gmail.com>
> After setting up my test company (US_IRS_1040), the following
> interesting fields (****) were blank in PartyAcctgPreference.
>
> partyId Company
> invoiceSeqCustMethId INV_HOOK_ENF_SEQ
> quoteSeqCustMethId ****
> orderSeqCustMethId ****
> refundPaymentMethodId ****
> errorGlJournalId ERROR_JOURNAL
> oldInvoiceSequenceEnumId INVSQ_ENF_SEQ
> oldOrderSequenceEnumId ODRSQ_ENF_SEQ
> oldQuoteSequenceEnumId QTESQ_ENF_SEQ
>
> Is it OK that they are blank, or is there a recommended value to set these to?
>
> Thanks