dynamicsusers: Abnormal Posting Dates

[Blog bot]

Abnormal posting date entries happens when the Posting Date of the receipt/shipments of inventory is after the Posting Date


of the invoice. Why does this happen? You'll need to ask your CFO or Controller. Typically, I found this more in return


orders where the receipt of the product is a certain date, and the accounting department decides to post the credit memo in


prior dates.


Either by mistake or intentional, if this happens, your Inventory Valuation will not tie to your G/L.


Here's a step by step on how to replicate this problem, and how to solve this problem:
1. Create a sales order with posting date of 11/01/08
2. Post the Shipment with a posting date of 11/01/08
3. Change the posting date to 09/01/08
4. Post the invoice
5. Run your inventory valuation report as of 9/30/08
6. Notice that the item is not taken out? But if you look at your G/L, the inventory value is taken out.


This will work for purchase side as well. It doesn't matter how to do it either using warehouse shipment/receive, the underlying process will net you the same problem.


Usually, problems like this won't come up until the user is trying to do month end and gets really frustrated on why their inventory doesn't tie to G/L. Unfortunately, there's no easy way to reverse this transaction after it's posted, the only way is to run a report at the end of the period to see what transactions have this "Abnormal Posting Dates".


Here's a report that will give you all the transactions that have abnormal posting dates. If you take this amount, add/subtract it to your inventory valuation report, it will be equal to the G/L inventory.


To run this report, just put the period you want to close on the Posting Date field. For example, if you're trying to close November 2008, then your Posting Date filter should be 11/1/08..11/30/08.


Here' the code for the report:


OBJECT Report 50075 Invt. Abnormal Posting Dates
{
OBJECT-PROPERTIES
{
Date=06/21/07;
Time=12:32:02 PM;
Modified=Yes;
Version List=;
}
PROPERTIES
{
OnPreReport=BEGIN
ValueFilter := "Value Entry".GETFILTERS;
END;


}
DATAITEMS
{
{ PROPERTIES
{
DataItemTable=Table5802;
DataItemTableView=SORTING(Document No.,Posting Date);
OnAfterGetRecord=BEGIN
ItemLedgEntry.GET("Item Ledger Entry No.");


IF ItemLedgEntry."Posting Date" <= "Posting Date" THEN
CurrReport.SKIP;


IF (ItemLedgEntry."Posting Date" >= GETRANGEMIN("Posting Date")) AND
(ItemLedgEntry."Posting Date" <= GETRANGEMAX("Posting Date")) THEN
CurrReport.SKIP;
END;


ReqFilterFields=Posting Date;
TotalFields=Cost Amount (Actual),Cost Posted to G/L;
}
SECTIONS
{
{ PROPERTIES
{
SectionType=Header;
PrintOnEveryPage=Yes;
SectionWidth=18150;
SectionHeight=2115;
}
CONTROLS
{
{ 1000000001;Label ;0 ;0 ;7500 ;423 ;FontSize=8;
FontBold=Yes;
CaptionML=ENU=Abnormal Item Posting Dates }
{ 1000000002;TextBox;15000;0 ;3150 ;423 ;HorzAlign=Right;
SourceExpr=FORMAT(TODAY,0,4) }
{ 1000000003;TextBox;0 ;423 ;7500 ;423 ;SourceExpr=COMPANYNAME }
{ 1000000004;TextBox;17700;423 ;450 ;423 ;CaptionML=ENU=Page;
SourceExpr=CurrReport.PAGENO }
{ 1000000005;Label ;16950;423 ;750 ;423 ;ParentControl=1000000004 }
{ 1000000006;TextBox;15900;846 ;2250 ;423 ;HorzAlign=Right;
SourceExpr=USERID }
{ 1000000019;TextBox;0 ;1269 ;13050;423 ;SourceExpr=ValueFilter }
{ 1000000022;TextBox;0 ;1692 ;13050;423 ;SourceExpr='Report displays item receipts or shipments posted AFTER


the invoice dates.' }
}
}
{ PROPERTIES
{
SectionType=Header;
PrintOnEveryPage=Yes;
SectionWidth=18150;
SectionHeight=1269;
}
CONTROLS
{
{ 1000000009;Label ;0 ;0 ;1050 ;846 ;ParentControl=1000000008;
VertAlign=Bottom;
FontBold=Yes;
MultiLine=Yes }
{ 1000000012;Label ;1200 ;0 ;1500 ;846 ;ParentControl=1000000011;
VertAlign=Bottom;
FontBold=Yes;
MultiLine=Yes }
{ 1000000015;Label ;2850 ;0 ;1200 ;846 ;ParentControl=1000000014;
VertAlign=Bottom;
FontBold=Yes;
MultiLine=Yes;
CaptionML=ENU=Posting Date }
{ 1000000018;Label ;4200 ;0 ;1500 ;846 ;ParentControl=1000000017;
VertAlign=Bottom;
FontBold=Yes;
MultiLine=Yes }
{ 1000000021;Label ;5850 ;0 ;1050 ;846 ;ParentControl=1000000020;
VertAlign=Bottom;
FontBold=Yes;
MultiLine=Yes }
{ 1000000024;Label ;9000 ;0 ;1800 ;846 ;ParentControl=1000000023;
VertAlign=Bottom;
FontBold=Yes;
MultiLine=Yes }
{ 1000000027;Label ;10950;0 ;1800 ;846 ;ParentControl=1000000026;
VertAlign=Bottom;
FontBold=Yes;
MultiLine=Yes }
{ 1000000000;Label ;7050 ;0 ;1800 ;846 ;VertAlign=Bottom;
FontBold=Yes;
MultiLine=Yes;
CaptionML=ENU=Item Ledger Posting Date }
{ 1000000028;Label ;13050;0 ;1350 ;846 ;ParentControl=1000000025;
VertAlign=Bottom;
FontBold=Yes;
MultiLine=Yes }
}
}
{ PROPERTIES
{
SectionType=Body;
SectionWidth=18150;
SectionHeight=423;
}
CONTROLS
{
{ 1000000008;TextBox;0 ;0 ;1050 ;423 ;HorzAlign=Right;
SourceExpr="Entry No." }
{ 1000000011;TextBox;1200 ;0 ;1500 ;423 ;HorzAlign=Left;
SourceExpr="Item No." }
{ 1000000014;TextBox;2850 ;0 ;1200 ;423 ;HorzAlign=Left;
SourceExpr="Posting Date" }
{ 1000000017;TextBox;4200 ;0 ;1500 ;423 ;HorzAlign=Left;
SourceExpr="Document No." }
{ 1000000020;TextBox;5850 ;0 ;1050 ;423 ;HorzAlign=Right;
SourceExpr="Item Ledger Entry No." }
{ 1000000023;TextBox;9000 ;0 ;1800 ;423 ;HorzAlign=Right;
SourceExpr="Cost Amount (Actual)" }
{ 1000000026;TextBox;10950;0 ;1800 ;423 ;HorzAlign=Right;
SourceExpr="Cost Posted to G/L" }
{ 1000000007;TextBox;7050 ;0 ;1800 ;423 ;HorzAlign=Right;
SourceExpr=ItemLedgEntry."Posting Date" }
{ 1000000025;TextBox;13050;0 ;1350 ;423 ;SourceExpr="Item Ledger Entry Type" }
}
}
{ PROPERTIES
{
SectionType=Footer;
SectionWidth=18150;
SectionHeight=846;
}
CONTROLS
{
{ 1000000010;TextBox;10950;423 ;1800 ;423 ;HorzAlign=Right;
SourceExpr="Cost Posted to G/L" }
{ 1000000013;TextBox;9000 ;423 ;1800 ;423 ;HorzAlign=Right;
SourceExpr="Cost Amount (Actual)" }
{ 1000000016;Label ;4800 ;423 ;4050 ;423 ;LeaderDots=Yes;
CaptionML=ENU=Total Posted Amount }
}
}
}
}
}
REQUESTFORM
{
PROPERTIES
{
Width=5500;
Height=1320;
}
CONTROLS
{
{ 1000000000;Label ;0 ;0 ;5500 ;1320 ;MultiLine=Yes;
LeaderDots=No;
CaptionML=ENU=Please fill in the date range for a particular period on the


Posting Date filter }
}
}
CODE
{
VAR
ItemLedgEntry@1000000000 : Record 32;
ValueFilter@1000000001 : Text[250];


BEGIN
END.
}
}









Подробнее... http://dynamicsuser.net/blogs/alexchow/arc...ting-dates.aspx