When the inter-company document failed to create in the subsidiary company, could be due to the add-on or Post Transaction Notification is not working, try below step to reprocess.
Assume AR - AP invoice transaction synchronization is setup correctly.
STEP
1. Turn off the SAP Business One InterCompany Windows service.
Make some changes in document and revert, then update the document. The purpose is to trigger an entry in the inter-company [BOY_F9_B1_IC_EVENTS] table.
2. Find the event Id made by the update in the event table.
DECLARE @DocNum int= ??
DECLARE @DocEntry nvarchar(12)
DECLARE @Id int
-- Find document ID for reprocessing
SELECT @Id = Id, @DocEntry = ListOfColsValTabDel
FROM [BOY_F9_B1_IC_EVENTS]
WHERE
ObjectType = '13' AND
ListOfColsValTabDel = (SELECT DocEntry FROM OINV WHERE DocNum = @DocNum)
-- List variable for validation
SELECT @Id AS Id, @DocNum AS DocNum, @DocEntry AS DocEntry
4. Update the event to have be an Add event instead of an Update event.
-- Change transactiontype Update to Add.
UPDATE [BOY_F9_B1_IC_EVENTS] SET TransactionType = 'A' WHERE Id = @Id
-- Check changes
SELECT * FROM [BOY_F9_B1_IC_EVENTS]
WHERE
ObjectType = '13' AND
ListOfColsValTabDel = @DocEntry
ORDER BY 1 DESC
5. Turn on the SAP Business One InterCompany window service.
The service will pick up the Add invoice event and synchronize to the subsidiary company.
2024-03-26 06:56:28.128 | Debug EventRunner - SalesInvoiceToInvoiceSynchronizer wants to work with: Id=4400
2024-03-26 06:56:28.128 | Info BaseSynchronizer - 51c34ac8c79244c79e230a6921ccc8eb BEGIN: [CONSO_PARENT] to [CONSO_COY1] SynchronizeEvent (CONSO_PARENT): Id=4400, ObjectType=13, EventType=Add, KeyAndValues=[DocEntry=31], Priority=0
2024-03-26 06:56:28.199 | Debug SboObjectDataFactory - GetData: [OINV].[DocEntry]=31: SboDocumentEx: Fields=[DocEntry=31, DocNum=100031, DocDate=3/21/2024 12:00:00 AM, DocDueDate=3/21/2024 12:00:00 AM, CardCode=IC001, DocCurrency=AUD, DocTotal=330, Address=Street
PERTH WA 6000
AUSTRALIA, NumAtCard=, Comments=TEST3, TransportationCode=-1, TaxDate=3/21/2024 12:00:00 AM, ShipToCode=, FederalTaxID=, DiscountPercent=0, RequriedDate=, CancelDate=, Project=, DocumentStatus=0, TrackingNumber=, OpeningRemarks=, ClosingRemarks=, ObjType=13], User defined fields=[]
2024-03-26 06:56:28.203 | Debug SboObjectDataFactory - GetDatas: [INV1].[DocEntry]=31: SboDocumentLineEx[].Length=1
2024-03-26 06:56:28.203 | Debug SboObjectDataFactory - GetDatas: [INV3].[DocEntry]=31: SboDocumentAdditionalExpenses[].Length=0
2024-03-26 06:56:28.203 | Debug SboObjectDataFactory - GetDatas: [INV10].[DocEntry]=31: SboObject[].Length=0
2024-03-26 06:56:28.203 | Debug SboObjectDataFactory - GetDatas: [INV2].[DocEntry]=31: SboDocumentLineAdditionalExpenses[].Length=0
2024-03-26 06:56:28.279 | Debug IntercompanyMapper - Mapping field [Currency]: AUD=>AUD
2024-03-26 06:56:28.417 | Debug FieldsHelper - Skipping property because value is null: PropertyName=RequriedDate
2024-03-26 06:56:28.417 | Debug FieldsHelper - Skipping property because value is null: PropertyName=CancelDate
2024-03-26 06:56:28.441 | Info InvoiceToDoubleInvoiceSynchronizer - Adding new purchase invoice (CONSO_COY1): CardCode=HQ001
2024-03-26 06:56:30.836 | Info BaseSynchronizer - 51c34ac8c79244c79e230a6921ccc8eb END: SynchronizeResult: Success
2024-03-26 06:56:30.845 | Debug BaseSynchronizer - Sending success message to users: [manager]
2024-03-26 06:56:30.908 | Debug EventRunner - Done working: SynchronizeEvent (CONSO_PARENT): Id=4400, ObjectType=13, EventType=Add, KeyAndValues=[DocEntry=31], Priority=0
To turn on IC Service Debug mode, change logger to Debug.
<rules>
<logger name="*" minlevel="Debug" writeTo="console,file" />
<!--<logger name="*" minlevel="Error" writeTo="buffer_mail"/>-->
</rules>
To turn off IC Service Debug mode, change logger to Info
<rules>
<logger name="*" minlevel="Info" writeTo="console,file" />
<!--<logger name="*" minlevel="Error" writeTo="buffer_mail"/>-->
</rules>