Accounting preferences and blank SeqCustMethod's

[Mike Z]

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

[Jacques Le Roux]

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" <[hidden email]>

> 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

[Mike Z]

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
<[hidden email]> 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" <[hidden email]>
>
>> 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

[Jacques Le Roux]

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" <[hidden email]>

> 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
> <[hidden email]> 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" <[hidden email]>
>>
>>> 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
>

[Mike Z]

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 <
[hidden email]> 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" <[hidden email]>
>
>  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
>> <[hidden email]> 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" <[hidden email]>
>>>
>>>  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
>>>>
>>>
>>

[Jacques Le Roux]

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" <[hidden email]>

> 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 <
> [hidden email]> 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" <[hidden email]>
>>
>>  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
>>> <[hidden email]> 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" <[hidden email]>
>>>>
>>>>  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
>>>>>
>>>>
>>>
>