SLS/P33.2C = (ITEMSALES.ITEMSALES.SalesCount * J1.MAPS.It...

[Nihitha Reddy Bhimireddy]

SLS/P33.2C = (ITEMSALES.ITEMSALES.SalesCount * J1.MAPS.ItemConfigValue);

SalesCount format : Actual is I15C and Usage is I5C and ConfigValue is P10.2C

The FOC1426 error is happening for SLS in a DEFINE.

Version: 8207.07

[Toby Mills]

Hi Nihitha

(FOC1426) DATA ELEMENT VALUE TOO BIG FOR SEGMENT/FIELD %1%2%3%4

An error occurred when converting a data item for the field in the

segment with the names given in the message. Data could not be

converted without truncation from the USAGE to the ACTUAL format.

FOCERROR is posted to 1426.

I forget lots of the error codes Thought Id put that up here for reference.

Looking around techsupport.ibi.com, I see that this error can pop up when your ACTUAL format is incorrectly specified in the Master file. I think Id suggest re-generating your masters that are involved to see if that helps. Save your old masters in case you want to put them back.

Heres a similar Troubleshooting doc from techsupport that talks about it.

A FOC1426 is thrown when trying to print * from a database

That example had extra complexity of narrowing down the field that was causing a problem, but the basic idea is that the Master files ACTUAL was incorrectly specified.

Let us know if that helps.

Toby

[NYCBabak .]

Try to SUM the two columns separately to make sure theyre both readable on their own.

Try a different format. Start with D12.2C and see if the DEFINE works.

[Nihitha Reddy Bhimireddy]

The data was decimal packed and want to view it as integer. Changed the ACTUAL to P5 and Usage to I6. and it worked.

Thanks @toby.mills and @nycbabak for your inputs.

[Toby Mills]

Cool deal Nihitha! Glad you got it figured out.

Toby