Why can't I Post my Commissary?

Why can't I Post my Commissary?

If you are getting this error message when attempting to Post your Commissary:

This Period Cannot be posted until all Locations for which the current Location is a Supply Location have posted all Post periods up to and including this Post period

You'll want to Post any Locations with this Commissary listed as a Supply Location. See, How do I know if my Locations have been Posted?

You can also remove the Commissary as a Supply Location if you don't want to post the other Location. If you don't know which location is linked, you can use this SQL or contact Support for help.

SELECT loc.location_name
	,post.post_inv_scheduled_date
	,loc.location_active
FROM t_location loc
	,t_location_supply_location sup
	,t_post post
WHERE post.post_inv_scheduled_date = (
		SELECT MAX(post1.post_inv_scheduled_date)
		FROM t_post post1
		WHERE post.location_id = post1.location_id
		)
	AND loc.location_id = sup.location_id
	AND loc.location_id = post.location_id
	AND post.post_type = 'inventory'
	AND sup.supply_location_id = 'Commissary Location Id'
ORDER BY post.post_inv_scheduled_date;

Related Articles

How do I know if my Locations have been Posted?

Why don’t I see the “Create Commissary Order “ option on Net-Chef?